Determines the Nth smallest value in a given field, either for the entire report or for each instance of the (condFld) group.
The following examples are applicable to both Basic and Crystal syntax:
NthSmallest (1, {Customer.CUSTOMER ID}
Returns 12, where the Customer ID field contains numerical values ranging from 12 to 50.
NthSmallest(1, {Customer.CUSTOMER NAME}, {Customer.REGION})
Returns the least value in the Customer Name field, per region.
NthSmallest({orders.ORDER AMOUNT}, {Customer.REGION}, "monthly")
Groups values in the Amount field by region, then returns the least value in the Amount field for each region, per month.
Note: Using this function in a formula forces the formula to be evaluated at print time.
For more information on evaluation time considerations, see Evaluation Time functions.
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |